2013-10-10 - 9203.200 - Spec - Sell Through Reporting #ABAP

SPECIFICATIONS

9203.200 - Sell Through Reporting

Purpose

Assign appropriate factory calendars to routes.

Admin Info

Purpose	Sell Through Reporting
Requested By	Mark Harris
Spec Created By	Venkat Kondapalyy
Spec Created Date	10/10/2013
Spec QA by	Venkat Kondapally
Objects
Document Status	WIP

References

Prior Tickets

Documents

Functional Requirement

Take input excel file and transform into an output feed for BW. Link up customer material information to SAP material ID. Read the Excel File and update the data into a Custom Table so that BW can access the data for its reporting.

The following fields are provided in the file.
Customer
Store
Date
Customer Material
NeC Material
Units
On Hand
Net Sales
Push%
UOM
Currency
Cust Material Description
Category

The data from the file with the above feilds should be read and saved in two custom tables.
ZSELTHR
ZCSUTMAT

Table ZSELTHR contains following fields
Customer
Cust Material
NEC_MATERIAL
Store
Sold To
Ship To
SDATE
Units
Quantity
UOM
Cusrrency
Push
week
Push UOM
Season
Collection

The Table ZCUSTMUST contains the following data.

CustMaterial
Cust Material Description
Category

Solution Summary

[Discuss this section with Requester and get approval prior to beginning work]

The data is read from Input File , processed and then saved into two Custom Tables.

Along with the data provided in the file additional fields like Sold To Party, Ship To Party , Season, Collection and Week are included. The data for the first four fields are fetched from data base tables wheras the last field is calculated based on the Date from File.